-- @owner: lihongji
-- @date: 2022/6/14
-- @testpoint:在匿名块中调用

--step1:创建序列    expect:创建序列成功
drop sequence if exists s_seq_conn_id;
create sequence s_seq_conn_id increment by 1 start with 100000;

--step2:清空数据    expect:成功
truncate table t_ustore_connection_id_0001;

--step3:插入数据    expect:成功
begin
 for i in 1..1000 loop
      insert into t_ustore_connection_id_0001 values(
s_seq_conn_id.nextval,to_timestamp('2019-01-03 14:58:54.000000','yyyy-mm-dd hh24:mi:ss.ffffff'),true,3.1415926,lpad('abc','30','a@123&^%djgk'),987,'asjk&%$454',10011.456789445455,lpad('abc','50','a@123&^%djgk'),'字符串',
false,'1001011',315454.1415926,99/4,'101101000111111101010',0,1,to_timestamp('2019-01-04 16:33:47.123456','yyyy-mm-dd hh24:mi:ss.ffffff'),'1',(interval '4 5:12:10.222' day to second(3)),
0,rpad('abc','10','e'),353848,rpad('abc','10','exc'),lpad('abc','30','a@123&^%djgk'),lpad('abc','20','a@123&^%djgk'),9745.548,-99,3141.5,to_timestamp('2019-01-04 16:33:47.123456','yyyy-mm-dd hh24:mi:ss.ffffff'),
to_timestamp('2019-01-03 14:58:54.000000','yyyy-mm-dd hh24:mi:ss.ffffff'),'a@123&^%djgk',(interval '12' year),' ','0','101101000111111101010','这是一个字符串',1/2.15,'0faadb9','a@123&^%djgk',
1.0e+100,3.14,4445.25,rpad('abc','10','&'),lpad('abc','10','&'),'abc&gdsh',125563.141592,rpad('abc','10','e'),'2019-01-03 14:14:12','a@123汉字&^%djgk',
+2,-1.79e+100,98*0.99,'1010101001010','abca@123&^%djgk','abca@123&^%djgk','2019-01-03 14:14:12',25563.1415,'a字符串@123&^%djgk',lpad('10',20,'01010'),
'1001010','2019-01-03 14:14:12','010101111111100000000000000','abc&gdsh','2019-01-03 15:19:00'
);
    end loop;
end;
/
